package com.kayt.cyberBar.cuser.business.dao;

import java.sql.SQLException;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;

import com.kayt.cyberBar.common.PageData;
import com.kayt.cyberBar.cuser.business.entity.po.BSheetUserFutureWork;

public interface ISheetUserFutureWorkDao {
	Integer save(BSheetUserFutureWork entity) throws SQLException;

	Integer update(BSheetUserFutureWork entity) throws SQLException;

	Integer delete(Integer id);

	void batchDelete(List<BSheetUserFutureWork> entityList);

	BSheetUserFutureWork findById(Integer id);

	BSheetUserFutureWork findBSheetUserFutureWorkByCode(String code) throws SQLException;

	public PageData<BSheetUserFutureWork> findByPage(int pageNum, int pageSize, String hql, Object[] params,
			LinkedHashMap<String, String> orderMap) throws SQLException;

	List<BSheetUserFutureWork> getFutureWork(String workCode, String startDate, String endDate) throws SQLException;

	void remove(BSheetUserFutureWork entity);

	BSheetUserFutureWork findBSheetUserFutureWork(String workCode, String shiftCode, String date) throws SQLException;

	BSheetUserFutureWork findBSheetUserFutureWorkByPositionCode(String positionCode, String shiftCode, String date)
			throws SQLException;

	List<Map<String, Object>> findBySotreCode(String sotreCode, String date) throws SQLException;
}
